﻿CREATE TABLE [dbo].[Stock] (
    [Gno]   INT        NOT NULL,
    [Gname] NCHAR (10) NULL,
    PRIMARY KEY CLUSTERED ([Gno] ASC),
    FOREIGN KEY ([Gno]) REFERENCES [dbo].[Goods] ([Gno]) ON DELETE CASCADE
);

